package com.kehutong.common;

import java.util.Arrays;
import java.util.List;

/**
 * Author:  peter
 * Date:    2020/7/24
 * Function:
 */
public class ExcelHeaders {
    private ExcelHeaders() {
    }

    public final static String[] JOB_PATROL_EXCEL_IMPORT_HEADER = {"小区名称","工作时间","工单名称","人力配备","状态"};

    /**
     * 月度抄表导出表头
     */
    public final static String[] CHARGE_MONTH_READ_EXCEL_IMPORT_HEADER = {"房屋信息、客户", "表号、表类", "上次读数", "本次读数",
            "仪表行度", "计费数量", "操作人、途径"};
    /**
     * 月度抄表模板表头
     */
    public final static String[] CHARGE_MONTH_READ_EXCEL_HEADER = {"抄表月份", "入户表id", "小区名称", "房屋信息", "当前客户",
            "仪表编号", "应用类型", "仪表类型", "仪表倍率", "最大读数", "上次读数", "上次读数日期", "本次读数", "本次读数日期"};

    /**
     * 常规标准选用导出表头
     */
    public final static String[] CHARGE_CHOOSE_CONVENTIONAL_EXECEL_HEADER = {"小区名称",
            "房屋信息", "当前业主", "费项名称", "绑定标准", "依据(单位)", "数量", "当前单价/月", "当前金额/月", "启用状态"};

    /**
     * 仪表选用导出表头
     */
    public final static String[] CHARGE_CHOOSE_INSTRUMENT_EXECEL_HEADER = {"小区名称",
            "房屋信息", "当前业主","仪表编号", "仪表类型", "费项名称", "绑定标准", "依据(单位)", "当前单价/月", "启用状态"};

    /**
     * 缴费任务导入表头
     */
    public final static String[] CHARGE_IMPORT_BILL_EXCEL_HEADER = {"房屋id", "小区名称", "楼栋/区域",
            "单元", "楼层", "房屋号", "账单周期（起）", "账单周期（止）", "应付款日"};

    /**
     * 缴费列表仪表导出表头
     */
    public final static String[] CHARGE_IMPORT_BILL_ITEM_INSTRUMENT_EXECEL_HEADER = {"费用id",
            "费用名称", "上次读数", "本次读数", "数量", "单价", "金额"};

    /**
     * 缴费列表常规导出表头
     */
    public final static String[] CHARGE_IMPORT_BILL_ITEM_CONVENTIONAL_EXECEL_HEADER = {"费用id",
            "费用名称", "金额"};

    /**
     * 缴费任务导出表头
     */
    public final static String[] CHARGE_BILL_EXPORT_EXCEL_HEADER = {"小区名称", "楼栋/区域",
            "单元", "楼层", "房屋号", "账单周期（起）", "账单周期（止）", "应付款日", "缴费金额", "启用状态", "缴费状态"};

    /**
     * 收缴率导出表头
     */
    public final static String[] CHARGE_STATISTICS_PAY_RATIO_EXPORT_EXCEL_HEADER = {"序号", "小区",
            "应收金额（元）", "已收金额（元）", "待收金额（元）", "收缴率"};
    /**
     * 收缴率-详情导出表头
     */
    public final static String[] CHARGE_STATISTICS_PAY_RATIO_DETAIL_EXPORT_EXCEL_HEADER = {"序号",
            "小区", "栋", "单元", "层", "房号", "业主姓名", "业主电话", "应收金额（元）", "已收金额（元）", "待收金额（元）"};
    /**
     * 待收账单列表导出表头
     */
    public final static String[] CHARGE_STATISTICS_UNPAID_BILL_EXPORT_EXCEL_HEADER = {"序号",
            "应付款日", "小区名称",
            "栋", "单元", "层", "房号", "业主姓名", "业主电话",
            "账单周期（起）", "账单周期（止）", "待收金额（元）"};
    /**
     * 已收账单列表导出表头
     */
    public final static String[] CHARGE_STATISTICS_PAID_BILL_EXPORT_EXCEL_HEADER = {"序号",
            "应付款日", "小区名称",
            "栋", "单元", "层", "房号", "账单周期（起）", "账单周期（止）",
            "收款金额（元）", "收款时间", "缴费方式"};
    /**
     * 资金流水列表导出表头
     */
    public final static String[] CHARGE_STATISTICS_CHARGE_RECORD_EXPORT_EXCEL_HEADER = {"序号",
            "商户单号", "交易流水号", "收款商户名称",
            "支付人","支付人电话" , "支付金额（元）", "支付时间", "支付来源"};
    /**
     * 预存款账户列表导出表头
     */
    public final static String[] CHARGE_ACCOUNT_HOUSE_EXPORT_EXCEL_HEADER = {"序号",
            "小区名称",
            "栋", "单元", "层", "房号", "业主姓名", "业主电话",
            "余额（元）"};

    /**
     * 创建房屋列表导出模板表头
     */
    public final static List<String> HOUSE_MSG_EXPORT_EXCEL_HEADER = Arrays.asList("所在小区",
            "楼栋", "单元", "楼层", "房间号", "业主姓名", "业主电话", "建筑面积", "使用面积", "计费面积");

}
